USE [Production2]
GO

/****** Object:  View [dbo].[V_CAL_PART_Line_Functional_Mapping]    Script Date: 10/28/2014 21:55:48 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[V_CAL_PART_Line_Functional_Mapping]'))
DROP VIEW [dbo].[V_CAL_PART_Line_Functional_Mapping]
GO

USE [Production2]
GO


/****** Object:  View [dbo].[V_CAL_PART_Line_Functional_Mapping]    Script Date: 12/02/2014 21:13:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO







CREATE VIEW [dbo].[V_CAL_PART_Line_Functional_Mapping]  
AS  
select distinct t.line_id, t.part_id, t.test_series_id, f.functional_test_id, t.test_series_description, f.functional_test_description
 from V_CAL_Part_Functional_Test f
inner join V_CAL_Part_Test_Series_Enable t
on f.test_series_id = t.test_series_id




GO


